compiling odbc

am 18.09.2008 20:10:15 von Brent Austin

--0-592471986-1221761415=:40504
Content-Type: text/plain; charset=us-ascii

I am attempting to compile and install psqlodbc-08.03.0200 on my Mac Pro running Leopard.
Here is what I get:
client-66-xxx-17-x14:psqlodbc-08.03.0200 brent1a$ sudo ./configure
checking for a BSD-compatible install... /usr/bin/install -c
checking whether build environment is sane... yes
checking for gawk... no
checking for mawk... no
checking for nawk... no
checking for awk... awk
checking whether make sets $(MAKE)... yes
checking whether to enable maintainer-specific portions of Makefiles... no
checking for pg_config... no
configure: error: pg_config not found (set PG_CONFIG environment variable)

How do I fix "configure: error: pg_config not found (set PG_CONFIG environment variable)"
(I'm relatively new to most of this?
thanks
-B

--0-592471986-1221761415=:40504
Content-Type: text/html; charset=us-ascii

I am attempting to compile and install psqlodbc-08.03.0200 on my Mac Pro running Leopard.

Here is what I get:

yle="font-size: 12px;">

client-66-xxx-17-x14:psqlodbc-08.03.0200 brent1a$ sudo ./configure

checking for a BSD-compatible install... /usr/bin/install -c

checking whether build environment is sane... yes

checking for gawk... no

checking for mawk... no

checking for nawk... no

checking for awk... awk

checking whether make sets $(MAKE)... yes

checking whether to enable maintainer-specific portions of Makefiles... no

checking for pg_config... no >

configure: error:
pg_config not found (set PG_CONFIG environment variable)

How do I fix "configure: error: pg_config not found (set PG_CONFIG environment variable)"

(I'm relatively new to most of this?

thanks t>

-B

--0-592471986-1221761415=:40504--

Re: compiling odbc

am 18.09.2008 20:52:00 von Tom Lane

Brent Austin writes:
> I am attempting to compile and install psqlodbc-08.03.0200 on my Mac Pro running Leopard.
> checking for pg_config... no
> configure: error: pg_config not found (set PG_CONFIG environment variable)

> How do I fix "configure: error: pg_config not found (set PG_CONFIG environment variable)"

Probably means you don't have Postgres itself installed. On some
platforms it could mean that you don't have the postgresql-devel
subpackage installed, but I've not heard that anyone divides up the
package like that on OS X.

Another possibility is that PG is installed, but in a directory
that's not in your PATH.

regards, tom lane

--
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

Re: compiling odbc

am 18.09.2008 21:15:07 von Brent Austin

--0-1630071379-1221765307=:65557
Content-Type: text/plain; charset=us-ascii

I just installed the latest Postgres from source so everything needed should be there. Some of the things I've been installing recently have not had the right PATH but I thought I fixed that. What would fix this problem?
I think postgres is installed in:
/usr/local/psql

would this fix it:
export PATH=$PATH:/usr/local/psql
or maybe
echo "export PATH=\"/usr/local/psql:$PATH\"" >>.bash_profile

----- Original Message ----
From: Tom Lane
To: Brent Austin
Cc: pgsql-odbc@postgresql.org
Sent: Thursday, September 18, 2008 1:52:00 PM
Subject: Re: [ODBC] compiling odbc

Brent Austin writes:
> I am attempting to compile and install psqlodbc-08.03.0200 on my Mac Pro running Leopard.
> checking for pg_config... no
> configure: error: pg_config not found (set PG_CONFIG environment variable)

> How do I fix "configure: error: pg_config not found (set PG_CONFIG environment variable)"

Probably means you don't have Postgres itself installed. On some
platforms it could mean that you don't have the postgresql-devel
subpackage installed, but I've not heard that anyone divides up the
package like that on OS X.

Another possibility is that PG is installed, but in a directory
that's not in your PATH.

regards, tom lane

--0-1630071379-1221765307=:65557
Content-Type: text/html; charset=us-ascii

I just installed the latest Postgres from source so everything needed should be there. Some of the things I've been installing recently have not had the right PATH but I thought I fixed that. What would fix this problem?

I think postgres is installed in:

/usr/local/psql

class="Apple-style-span" style="font-size:small;">would this fix it:

export PATH=$PATH:/usr/local/psql

or maybe

echo "export PATH=\"/usr/local/psql:$PATH\"" >> .bash_profile

----- Original Message ----
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Brent Austin <brent1a@yahoo.com>
Cc: pgsql-odbc@postgresql.org
Sent: Thursday, September 18, 2008 1:52:00 PM
Subject: Re: [ODBC] compiling odbc

Brent Austin <> writes:
> I am attempting to compile and install psqlodbc-08.03.0200 on my Mac Pro running Leopard.
> checking for pg_config... no
> configure: error: pg_config not found (set PG_CONFIG environment variable)

> How do I fix "configure: error: pg_config not found (set PG_CONFIG environment variable)"

Probably means you don't have Postgres itself installed. On some
platforms it could mean that you don't have the postgresql-devel
subpackage installed, but I've not heard that anyone divides up the
package like that on OS X.

Another possibility is that PG is installed, but in a directory
that's
not in your PATH.

regards, tom lane

--0-1630071379-1221765307=:65557--

Re: compiling odbc

am 18.09.2008 21:18:53 von Brent Austin

--0-1595947859-1221765533=:79132
Content-Type: text/plain; charset=us-ascii

My pg_config file is in: /usr/local/pgsql/bin so how do I tell terminal to see that it's there instead of where it thinks it is?

----- Original Message ----
From: Brent Austin
To: pgsql-odbc@postgresql.org
Sent: Thursday, September 18, 2008 2:15:07 PM
Subject: Re: [ODBC] compiling odbc

I just installed the latest Postgres from source so everything needed should be there. Some of the things I've been installing recently have not had the right PATH but I thought I fixed that. What would fix this problem?
I think postgres is installed in:
/usr/local/psql

would this fix it:
export PATH=$PATH:/usr/local/psql
or maybe
echo "export PATH=\"/usr/local/psql:$PATH\"" >>.bash_profile

----- Original Message ----
From: Tom Lane
To: Brent Austin
Cc: pgsql-odbc@postgresql.org
Sent: Thursday, September 18, 2008 1:52:00 PM
Subject: Re: [ODBC] compiling odbc

Brent Austin writes:
> I am attempting to compile and install psqlodbc-08.03.0200 on my Mac Pro running Leopard.
> checking for pg_config... no
> configure: error: pg_config not found (set PG_CONFIG environment variable)

> How do I fix "configure: error: pg_config not found (set PG_CONFIG environment variable)"

Probably means you don't have Postgres itself installed. On some
platforms it could mean that you don't have the postgresql-devel
subpackage installed, but I've not heard that anyone divides up the
package like that on OS X.

Another possibility is that PG is installed, but in a directory
that's not in your PATH.

regards, tom lane

--0-1595947859-1221765533=:79132
Content-Type: text/html; charset=us-ascii

My pg_config file is in: /usr/local/pgsql/bin so how do I tell terminal to see that it's there instead of where it thinks it is?

----- Original Message ----
From: Brent Austin <brent1a@yahoo.com>
To: pgsql-odbc@postgresql.org
Sent: Thursday, September 18, 2008 2:15:07 PM
Subject: Re: [ODBC] compiling odbc

I think postgres is installed in:

/usr/local/psql

class="Apple-style-span" style="font-size:small;">would this fix it:

export PATH=$PATH:/usr/local/psql

or maybe

echo "export PATH=\"/usr/local/psql:$PATH\"" >> .bash_profile

--0-1595947859-1221765533=:79132--

Re: compiling odbc

am 19.09.2008 08:35:20 von Albe Laurenz

Brent Austin wrote:
> My pg_config file is in: /usr/local/pgsql/bin so how do I=20
> tell terminal to see that it's there instead of where it thinks it is?
>=20
> would this fix it:
>=20
> export PATH=3D$PATH:/usr/local/psql

Erm, no.
Try:

export PATH=3D$PATH:/usr/local/psql/bin

Yours,
Laurenz Albe

--=20
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

Re: compiling odbc

am 19.09.2008 10:33:19 von Brent Austin

--0-55704902-1221813199=:10875
Content-Type: text/plain; charset=us-ascii

So far this is what I get when I try that command-

client-66-1xx-17-xx4:~ brent1a$ export PATH=$PATH:/usr/local/psql/bin
client-66-1xx-17-xx4:~ brent1a$ cd /psqlodbc-08.03.0200
client-66-1xx-17-xx4:psqlodbc-08.03.0200 brent1a$ sudo ./configure
Password:
checking for a BSD-compatible install... /usr/bin/install -c
checking whether build environment is sane... yes
checking for gawk... no
checking for mawk... no
checking for nawk... no
checking for awk... awk
checking whether make sets $(MAKE)... yes
checking whether to enable maintainer-specific portions of Makefiles... no
checking for pg_config... no
configure: error: pg_config not found (set PG_CONFIG environment variable)
client-66-1xx-17-xx4:psqlodbc-08.03.0200 brent1a$

----- Original Message ----
From: Albe Laurenz
To: Brent Austin *EXTERN* ; pgsql-odbc@postgresql.org
Sent: Friday, September 19, 2008 1:35:20 AM
Subject: RE: [ODBC] compiling odbc

Brent Austin wrote:
> My pg_config file is in: /usr/local/pgsql/bin so how do I
> tell terminal to see that it's there instead of where it thinks it is?
>
> would this fix it:
>
> export PATH=$PATH:/usr/local/psql

Erm, no.
Try:

export PATH=$PATH:/usr/local/psql/bin

Yours,
Laurenz Albe

--0-55704902-1221813199=:10875
Content-Type: text/html; charset=us-ascii

So far this is what I get when I try that command-

client-66-1xx-17-xx4:~ brent1a$ export PATH=$PATH:/usr/local/psql/bin

client-66-1xx-17-xx4:~ brent1a$ cd /psqlodbc-08.03.0200

client-66-1xx-17-xx4:psqlodbc-08.03.0200 brent1a$ sudo ./configure

Password:

checking for a BSD-compatible install... /usr/bin/install -c

checking whether build environment is sane... yes

checking for gawk... no

checking for mawk... no

checking for nawk... no

checking for awk... awk

checking whether make sets $(MAKE)... yes

checking whether to enable maintainer-specific portions of Makefiles... no

checking for pg_config... no

configure: error: pg_config not found (set PG_CONFIG environment variable)

client-66-1xx-17-xx4:psqlodbc-08.03.0200 brent1a$

----- Original Message ----
From: Albe Laurenz <laurenz.albe@wien.gv.at>
To: Brent Austin *EXTERN* <brent1a@yahoo.com>; pgsql-odbc@postgresql.org
Sent: Friday, September 19, 2008 1:35:20 AM
Subject: RE: [ODBC] compiling odbc

Brent Austin wrote:
> My pg_config file is in: /usr/local/pgsql/bin so how do I
> tell terminal to see that it's there instead of where it thinks it is?
>
> would this fix it:
>
> export PATH=$PATH:/usr/local/psql

Erm, no.
Try:

export PATH=$PATH:/usr/local/psql/bin

Yours,
Laurenz Albe

--0-55704902-1221813199=:10875--

Re: compiling odbc

am 19.09.2008 13:11:40 von Albe Laurenz

> So far this is what I get when I try that command-
>=20
> client-66-1xx-17-xx4:~ brent1a$ export PATH=3D$PATH:/usr/local/psql/bin
>=20
> client-66-1xx-17-xx4:~ brent1a$ cd /psqlodbc-08.03.0200=20
>=20
> client-66-1xx-17-xx4:psqlodbc-08.03.0200 brent1a$ sudo ./configure
>=20
[...]
>=20
> configure: error: pg_config not found (set PG_CONFIG environment variable)

Yeah, sure.

You should omit the "sudo", it's wrong.

But maybe it's best to follow the instructions you get and
export PG_CONFIG=3D/usr/local/psql/bin/pg_config

Yours,
Laurenz Albe

--=20
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

Re: compiling odbc

am 19.09.2008 13:35:23 von Jeremy Faith

Hi,

Brent Austin wrote:
> My pg_config file is in: /usr/local/pgsql/bin so how do I
> tell terminal to see that it's there instead of where it thinks it is?
>
> would this fix it:
>
> export PATH=$PATH:/usr/local/psql

Could this be as simple as the 'g' being missing from the pgsql directory in the PATH?
i.e.
export PATH=$PATH:/usr/local/psql
should be
export PATH=$PATH:/usr/local/pgsql
and
export PG_CONFIG=/usr/local/psql/bin/pg_config
should be
export PG_CONFIG=/usr/local/pgsql/bin/pg_config

Regards,
Jeremy Faith

Albe Laurenz wrote:
>> So far this is what I get when I try that command-
>>
>> client-66-1xx-17-xx4:~ brent1a$ export PATH=$PATH:/usr/local/psql/bin
>>
>> client-66-1xx-17-xx4:~ brent1a$ cd /psqlodbc-08.03.0200
>>
>> client-66-1xx-17-xx4:psqlodbc-08.03.0200 brent1a$ sudo ./configure
>>
>>
> [...]
>
>> configure: error: pg_config not found (set PG_CONFIG environment variable)
>>
>
> Yeah, sure.
>
> You should omit the "sudo", it's wrong.
>
> But maybe it's best to follow the instructions you get and
> export PG_CONFIG=/usr/local/psql/bin/pg_config
>
> Yours,
> Laurenz Albe
>
>

--
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

Re: compiling odbc

am 19.09.2008 20:25:31 von Brent Austin

--0-524070078-1221848731=:1781
Content-Type: text/plain; charset=us-ascii

I got export PATH=$PATH:/usr/local/pgsql to work

but now I get:
"configure: error: unixODBC library "odbcinst" not found"

I found that "odbcinst" is in my /opt/local/bin

How do I tell configure that pgsql is in /usr/local/pgsql and ALSO tell it that obcinst is in /opt/local/bin ???

----- Original Message ----
From: Jeremy Faith
To: pgsql-odbc@postgresql.org
Sent: Friday, September 19, 2008 6:35:23 AM
Subject: Re: [ODBC] compiling odbc

Hi,

Brent Austin wrote:
> My pg_config file is in: /usr/local/pgsql/bin so how do I
> tell terminal to see that it's there instead of where it thinks it is?
>
> would this fix it:
>
> export PATH=$PATH:/usr/local/psql

Could this be as simple as the 'g' being missing from the pgsql directory in the PATH?
i.e.
export PATH=$PATH:/usr/local/psql
should be
export PATH=$PATH:/usr/local/pgsql
and
export PG_CONFIG=/usr/local/psql/bin/pg_config
should be
export PG_CONFIG=/usr/local/pgsql/bin/pg_config

Regards,
Jeremy Faith

Albe Laurenz wrote:
>> So far this is what I get when I try that command-
>>
>> client-66-1xx-17-xx4:~ brent1a$ export PATH=$PATH:/usr/local/psql/bin
>>
>> client-66-1xx-17-xx4:~ brent1a$ cd /psqlodbc-08.03.0200
>>
>> client-66-1xx-17-xx4:psqlodbc-08.03.0200 brent1a$ sudo ./configure
>>
>>
> [...]
>
>> configure: error: pg_config not found (set PG_CONFIG environment variable)
>>
>
> Yeah, sure.
>
> You should omit the "sudo", it's wrong.
>
> But maybe it's best to follow the instructions you get and
> export PG_CONFIG=/usr/local/psql/bin/pg_config
>
> Yours,
> Laurenz Albe
>
>

--
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

--0-524070078-1221848731=:1781
Content-Type: text/html; charset=us-ascii

I got export PATH=$PATH:/usr/local/pgsql to work

but now I get:

"configure: error: unixODBC library "odbcinst" not found"

I found that "odbcinst" is in my /opt/local/bin

How do I tell configure that pgsql is in /usr/local/pgsql and ALSO tell it that obcinst is in /opt/local/bin ???

----- Original Message ----
From: Jeremy Faith <jfaith@cemsys.com>

To: pgsql-odbc@postgresql.org
Sent: Friday, September 19, 2008 6:35:23 AM
Subject: Re: [ODBC] compiling odbc

Hi,

Brent Austin wrote:
> My pg_config file is in: /usr/local/pgsql/bin so how do I
> tell terminal to see that it's there instead of where it thinks it is?
>
> would this fix it:
>
> export PATH=$PATH:/usr/local/psql

Could this be as simple as the 'g' being missing from the pgsql directory in the PATH?
i.e.
export PATH=$PATH:/usr/local/psql
should be
export PATH=$PATH:/usr/local/pgsql
and
export PG_CONFIG=/usr/local/psql/bin/pg_config
should be
export PG_CONFIG=/usr/local/pgsql/bin/pg_config

Regards,
Jeremy Faith

Albe Laurenz wrote:
>> So far this is what I get when I try that command-
>>
>> client-66-1xx-17-xx4:~ brent1a$ exp
ort PATH=$PATH:/usr/local/psql/bin
>>
>> client-66-1xx-17-xx4:~ brent1a$ cd /psqlodbc-08.03.0200
>>
>>
client-66-1xx-17-xx4:psqlodbc-08.03.0200 brent1a$ sudo ./configure
>>
>>
> [...]
>
>> configure: error: pg_config not found (set PG_CONFIG environment variable)
>>
>
> Yeah, sure.
>
> You should omit the "sudo", it's wrong.
>
> But maybe it's best to follow the instructions you get and
> export PG_CONFIG=/usr/local/psql/bin/pg_config
>
> Yours,
> Laurenz Albe
>
>

--
Sent via pgsql-odbc mailing list ()
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odb c

--0-524070078-1221848731=:1781--

Re: compiling odbc

am 19.09.2008 22:11:36 von Tom Lane

Brent Austin writes:
> How do I tell configure that pgsql is in /usr/local/pgsql and ALSO tell it that obcinst is in /opt/local/bin ???

Two PATH items?

regards, tom lane

--
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

Re: compiling odbc

am 20.09.2008 00:49:16 von Brent Austin

--0-635509740-1221864556=:15314
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

Yes, two PATH items, I guess.=0A"export PATH=3D$PATH:/usr/local/pgsql"=0A=
takes care of: =0A"checking for pg_config... no=0Aconfigure: err=
or: pg_config not found (set PG_CONFIG environment variable)" =0AHow c=
an I take care of the following as well with out messing up the above? =0A=
"configure: error: unixODBC library "odbcinst" not found" (I fou=
nd=A0"odbcinst" is in my /opt/local/bin) =0A----- Original Message ---=
-=0AFrom: Tom Lane =0ATo: Brent Austin m>=0ACc: Jeremy Faith ; pgsql-odbc@postgresql.org=0ASent=
: Friday, September 19, 2008 3:11:36 PM=0ASubject: Re: [ODBC] compiling odb=
c Brent Austin writes:=0A> How do I tell configure=
that pgsql is in /usr/local/pgsql and ALSO tell it that obcinst is in /opt=
/local/bin ??? Two PATH items? =A0 =A0 =A0 rega=
rds, tom lane
--0-635509740-1221864556=:15314
Content-Type: text/html; charset=us-ascii

Yes, two PATH items, I guess.

"export PATH=$PATH:/usr/local/pgsql"

takes care of:

"checking for pg_config... no

configure: error: pg_config not found (set PG_CONFIG environment variable)"

How can I take care of the following as well with out messing up the above?

"configure: error: unixODBC library "odbcinst" not found"

(I found "odbcinst" is in my /opt/local/bin)

----- Original Message ----
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Brent Austin <brent1a@yahoo.com>
Cc: Jeremy Faith <jfaith@cemsys.com>; pgsql-odbc@postgresql.org
Sent: Friday, September 19, 2008 3:11:36 PM
Subject: Re: [ODBC] compiling odbc

Brent Austin <> writes:
> How do I tell configure that pgsql is in /usr/local/pgsql and ALSO tell it that obcinst is in /opt/local/bin ???

Two PATH items?

regards, tom lane

--0-635509740-1221864556=:15314--

Re: compiling odbc

am 22.09.2008 11:06:28 von Jeremy Faith

Hi,

I think what Tom is saying is to try:-
PATH=$PATH:/usr/local/pgsql:/opt/local/bin

Regards,
Jeremy Faith

Brent Austin wrote:
> Yes, two PATH items, I guess.
> "export PATH=$PATH:/usr/local/pgsql"
>
> takes care of:
>
> "checking for pg_config... no
> configure: error: pg_config not found (set PG_CONFIG environment
> variable)"
>
> How can I take care of the following as well with out messing up the
> above?
>
> "configure: error: unixODBC library "odbcinst" not found"
>
> (I found "odbcinst" is in my /opt/local/bin)
>
> ----- Original Message ----
> From: Tom Lane
> To: Brent Austin
> Cc: Jeremy Faith ; pgsql-odbc@postgresql.org
> Sent: Friday, September 19, 2008 3:11:36 PM
> Subject: Re: [ODBC] compiling odbc
>
> Brent Austin > writes:
> > How do I tell configure that pgsql is in /usr/local/pgsql and ALSO
> tell it that obcinst is in /opt/local/bin ???
>
> Two PATH items?
>
> regards, tom lane
>

--
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

Re: compiling odbc

am 22.09.2008 12:01:23 von Brent Austin

--0-1039446695-1222077683=:64809
Content-Type: text/plain; charset=us-ascii

I still get this:
client-66-1xx-1x-x14:~ brent1a$ PATH=$PATH:/usr/local/pgsql/bin:/opt/local/bin
client-66-1xx-1x-x14:~ brent1a$ cd /psqlodbc-08.03.0200
client-66-1xx-1x-x14:psqlodbc-08.03.0200 brent1a$ sudo ./configure
checking for a BSD-compatible install... /usr/bin/install -c
checking whether build environment is sane... yes
checking for gawk... no
checking for mawk... no
checking for nawk... no
checking for awk... awk
checking whether make sets $(MAKE)... yes
checking whether to enable maintainer-specific portions of Makefiles... no
checking for pg_config... /usr/local/pgsql/bin/pg_config
checking for gcc... gcc
............
checking how to hardcode library paths into programs... immediate
checking for library containing SQLGetPrivateProfileString... no
configure: error: unixODBC library "odbcinst" not found
client-66-1xx-1x-x14:psqlodbc-08.03.0200 brent1a$

----- Original Message ----
From: Jeremy Faith
To: pgsql-odbc@postgresql.org
Sent: Monday, September 22, 2008 4:06:28 AM
Subject: Re: [ODBC] compiling odbc

Hi,

I think what Tom is saying is to try:-
PATH=$PATH:/usr/local/pgsql:/opt/local/bin

Regards,
Jeremy Faith

Brent Austin wrote:
> Yes, two PATH items, I guess.
> "export PATH=$PATH:/usr/local/pgsql"
>
> takes care of:
>
> "checking for pg_config... no
> configure: error: pg_config not found (set PG_CONFIG environment
> variable)"
>
> How can I take care of the following as well with out messing up the
> above?
>
> "configure: error: unixODBC library "odbcinst" not found"
>
> (I found "odbcinst" is in my /opt/local/bin)
>
> ----- Original Message ----
> From: Tom Lane
> To: Brent Austin
> Cc: Jeremy Faith ; pgsql-odbc@postgresql.org
> Sent: Friday, September 19, 2008 3:11:36 PM
> Subject: Re: [ODBC] compiling odbc
>
> Brent Austin > writes:
> > How do I tell configure that pgsql is in /usr/local/pgsql and ALSO
> tell it that obcinst is in /opt/local/bin ???
>
> Two PATH items?
>
> regards, tom lane
>

--
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

--0-1039446695-1222077683=:64809
Content-Type: text/html; charset=us-ascii

I still get this:

client-66-1xx-1x-x14:~ brent1a$ PATH=$PATH:/usr/local/pgsql/bin:/opt/local/bin

client-66-1xx-1x-x14:~ brent1a$ cd /psqlodbc-08.03.0200

client-66-1xx-1x-x14:psqlodbc-08.03.0200 brent1a$ sudo ./configure

checking for a BSD-compatible install... /usr/bin/install -c

checking whether build environment is sane... yes

checking for gawk... no

checking for mawk... no

checking for nawk... no

checking for awk... awk

checking whether make sets $(MAKE)... yes

checking whether to enable maintainer-specific po
rtions of Makefiles... no

checking for pg_config... /usr/local/pgsql/bin/pg_config

checking for gcc...
gcc

...........

checking how to hardcode library paths into programs... immediate

checking for library containing SQLGetPrivateProfileString... no

configure: error: unixODBC library "odbcinst" not found

client-66-1xx-1x-x14:psqlodbc-08.03.0200 brent1a$

----- Original Message ----
From: Jeremy Faith <jfaith@cemsys.com>
To: pgsql-odbc@postgresql.org
Sent: Monday, September 22, 2008 4:06:28 AM
Subject: Re: [ODBC] compiling odbc

Hi,

I think what Tom is saying is to try:-
PATH=$PATH:/usr/local/pgsql:/opt/local/bin

Regards,
Jeremy Faith

Brent Austin wrote:
> Yes, two PATH items, I guess.
> "export PATH=$PATH:/usr/local/pgsql"
>
> takes care of:
>
> "checking for pg_config... no
> configure: error: pg_config not found (set PG_CONFIG environment
> variable)"
>
> How can I take care of the following as well with out messing up the
> above?
>
> "configure: error: unixODBC library "odbcinst" not found"
>
> (I found "odbcinst" is in my /opt/local/bin)
>
> ----- Original Message ----
> From: Tom Lane <tgl@sss.pgh.pa.us>
> To: Brent Austin < href="mailto:brent1a@yahoo.com">brent1a@yahoo.com>
> Cc: Jeremy Faith <>> writes:
> > How do I tell configure that pgsql is in /usr/local/pgsql and ALSO
> tell it that obcinst is in /opt/local/bin ???
>
> Two PATH
items?
>
> regards, tom lane
>

--
Sent via pgsql-odbc mailing list ( ymailto="mailto:pgsql-odbc@postgresql.org" href="mailto:pgsql-odbc@postgresql.org">pgsql-odbc@postgresq l.org)
To make changes to your subscription:

--0-1039446695-1222077683=:64809--

Re: compiling odbc

am 22.09.2008 12:36:19 von Zoltan Boszormenyi

Brent Austin =EDrta:
> I still get this:
> client-66-1xx-1x-x14:~ brent1a$
> PATH=3D$PATH:/usr/local/pgsql/bin:/opt/local/bin
> client-66-1xx-1x-x14:~ brent1a$ cd /psqlodbc-08.03.0200=20
> client-66-1xx-1x-x14:psqlodbc-08.03.0200 brent1a$ sudo ./configure
> checking for a BSD-compatible install... /usr/bin/install -c
> checking whether build environment is sane... yes
> checking for gawk... no
> checking for mawk... no
> checking for nawk... no
> checking for awk... awk
> checking whether make sets $(MAKE)... yes
> checking whether to enable maintainer-specific portions of Makefiles...=
no
> checking for pg_config... /usr/local/pgsql/bin/pg_config
> checking for gcc... gcc
> ...........
> checking how to hardcode library paths into programs... immediate
> checking for library containing SQLGetPrivateProfileString... no
> *configure: error: unixODBC library "odbcinst" not found*
> client-66-1xx-1x-x14:psqlodbc-08.03.0200 brent1a$

You need unixODBC or iODBC installed. unixODBC is used by default,
you can change the expected ODBC manager with option --with-iodbc.

> ----- Original Message ----
> From: Jeremy Faith
> To: pgsql-odbc@postgresql.org
> Sent: Monday, September 22, 2008 4:06:28 AM
> Subject: Re: [ODBC] compiling odbc
>
> Hi,
>
> I think what Tom is saying is to try:-
> PATH=3D$PATH:/usr/local/pgsql:/opt/local/bin
>
> Regards,
> Jeremy Faith
>
> Brent Austin wrote:
> > Yes, two PATH items, I guess.
> > "export PATH=3D$PATH:/usr/local/pgsql"
> >=20
> > takes care of:
> >=20
> > "checking for pg_config... no
> > configure: error: pg_config not found (set PG_CONFIG environment
> > variable)"
> >=20
> > How can I take care of the following as well with out messing up the
> > above?
> >
> > "configure: error: unixODBC library "odbcinst" not found"
> >
> > (I found "odbcinst" is in my /opt/local/bin)
> >
> > ----- Original Message ----
> > From: Tom Lane >
> > To: Brent Austin >
> > Cc: Jeremy Faith >;
> pgsql-odbc@postgresql.org
> > Sent: Friday, September 19, 2008 3:11:36 PM
> > Subject: Re: [ODBC] compiling odbc
> >
> > Brent Austin
> >> writes:
> > > How do I tell configure that pgsql is in /usr/local/pgsql and ALSO
> > tell it that obcinst is in /opt/local/bin ???
> >
> > Two PATH items?
> >
> > regards, tom lane
> >
>
>
> --=20
> Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org
> )
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-odbc
>

--=20
----------------------------------
Zolt=E1n Böszörm=E9nyi
Cybertec Schönig & Schönig GmbH
http://www.postgresql.at/

--=20
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

Re: compiling odbc

am 22.09.2008 19:28:49 von Brent Austin

--0-1483291421-1222104529=:58269
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

That's the thing, I have unixODBC installed, it is located at /opt/local/bi=
n that is why I need help figuring out how to get the terminal to recognize=
where both pg_config AND obdcinst are at during the ./configure process. =
=0APATH=3D$PATH:/usr/local/pgsql/bin:/opt/local/bin should work but it's =
not recognizing the second part.....the odncinst part. ----- Ori=
ginal Message ----=0AFrom: Zoltan Boszormenyi =0ATo: Brent =
Austin =0ACc: Jeremy Faith ; pgsql-od=
bc@postgresql.org=0ASent: Monday, September 22, 2008 5:36:19 AM=0ASubject: =
Re: [ODBC] compiling odbc Brent Austin =EDrta:=0A> I still get this: =
=0A> client-66-1xx-1x-x14:~ brent1a$=0A> PATH=3D$PATH:/usr/local/pgsql/bin=
:/opt/local/bin=0A> client-66-1xx-1x-x14:~ brent1a$ cd /psqlodbc-08.03.0200=
=0A> client-66-1xx-1x-x14:psqlodbc-08.03.0200 brent1a$ sudo ./configure=0A=
> checking for a BSD-compatible install... /usr/bin/install -c=0A> checking=
whether build environment is sane... yes=0A> checking for gawk... no=0A> c=
hecking for mawk... no=0A> checking for nawk... no=0A> checking for awk... =
awk=0A> checking whether make sets $(MAKE)... yes=0A> checking whether to e=
nable maintainer-specific portions of Makefiles... no=0A> checking for pg_c=
onfig... /usr/local/pgsql/bin/pg_config=0A> checking for gcc... gcc=0A> ...=
.........=0A> checking how to hardcode library paths into programs... immedi=
ate=0A> checking for library containing SQLGetPrivateProfileString... no=0A=
> *configure: error: unixODBC library "odbcinst" not found*=0A> client-66-1=
xx-1x-x14:psqlodbc-08.03.0200 brent1a$ You need unixODBC or iODBC inst=
alled. unixODBC is used by default,=0Ayou can change the expected ODBC mana=
ger with option --with-iodbc. > ----- Original Message ----=0A> From: =
Jeremy Faith =0A> To: pgsql-odbc@postgresql.org=0A> Sent=
: Monday, September 22, 2008 4:06:28 AM=0A> Subject: Re: [ODBC] compiling o=
dbc=0A>=0A> Hi,=0A>=0A> I think what Tom is saying is to try:-=0A> PATH=
=3D$PATH:/usr/local/pgsql:/opt/local/bin=0A>=0A> Regards,=0A> Jeremy Faith=
=0A>=0A> Brent Austin wrote:=0A> > Yes, two PATH items, I guess.=0A> > "exp=
ort PATH=3D$PATH:/usr/local/pgsql"=0A> > =0A> > takes care of:=0A> > =0A> >=
"checking for pg_config... no=0A> > configure: error: pg_config not found =
(set PG_CONFIG environment=0A> > variable)"=0A> > =0A> > How can I take car=
e of the following as well with out messing up the=0A> > above?=0A> >=0A> >=
"configure: error: unixODBC library "odbcinst" not found"=0A> >=0A> > (I f=
ound "odbcinst" is in my /opt/local/bin)=0A> >=0A> > ----- Original Message=
----=0A> > From: Tom Lane >=
=0A> > To: Brent Austin >=0A> =
> Cc: Jeremy Faith >;=0A> pgsq=
l-odbc@postgresql.org =0A> > Sent: Friday=
, September 19, 2008 3:11:36 PM=0A> > Subject: Re: [ODBC] compiling odbc=0A=
> >=0A> > Brent Austin =0A> ailto:brent1a@yahoo.com >> writes:=0A> > > How do=
I tell configure that pgsql is in /usr/local/pgsql and ALSO=0A> > tell it =
that obcinst is in /opt/local/bin ???=0A> >=0A> > Two PATH items?=0A> >=0A>=
> regards, tom lane=0A> >=0A>=0A>=0A> -- =0A> Sent via pgsql-od=
bc mailing list (pgsql-odbc@postgresql.org=0A> l.org>)=0A> To make changes to your subscription:=0A> http://www.postgresql=
..org/mailpref/pgsql-odbc=0A> =0A-- =0A--------------------------------=
--=0AZolt=E1n Böszörm=E9nyi=0ACybertec Schönig & Schönig GmbH=0Ahtt=
p://www.postgresql.at/ =0A
--0-1483291421-1222104529=:58269
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

ad>

2pt">

That=
's the thing, I have unixODBC installed, it is located at /opt/local/b=
in that is why I need help figuring out how to get the terminal to recogniz=
e where both pg_config AND obdcinst are at during the ./configure process. =

ont-size:12pt"> >PATH=3D$PATH:/usr/local/pgsql/bin:/opt/local/bin should work but it=
's not recognizing the second part.....the odncinst part.

style=3D"font-family:arial, helvetica, sans-serif;font-size:12pt"> ss=3D"Apple-style-span" size=3D"3"> =3D"font-size: 13px;">

al, helvetica,
sans-serif;font-size:12pt"> an class=3D"Apple-style-span" style=3D"font-size: 13px;">
=

----=
- Original Message ----
From: Zoltan Boszormenyi <zb@cybertec.at><=
br>To: Brent Austin <brent1a@yahoo.com>
Cc: Jeremy Faith <jfait=
h@cemsys.com>; pgsql-odbc@postgresql.org
Sent: Monday, September 22, =
2008 5:36:19 AM
Subject: Re: [ODBC] compiling odbc

=0ABrent Austi=
n =EDrta:
> I still get this:
> client-66-1xx-1x-x=
14:~ brent1a$
> PATH=3D$PATH:/usr/local/pgsql/bin:/opt/local/bin
&=
gt; client-66-1xx-1x-x14:~ brent1a$ cd /psqlodbc-08.03.0200
> client=
-66-1xx-1x-x14:psqlodbc-08.03.0200 brent1a$ sudo ./configure
> checki=
ng for a BSD-compatible install... /usr/bin/install -c
> checking whe=
ther build environment is sane... yes
> checking for gawk... no
&g=
t; checking for mawk... no
> checking for nawk... no
> checking=
for awk... awk
> checking whether make sets $(MAKE)... yes
> c=
hecking whether to enable maintainer-specific portions of Makefiles... no r>> checking for pg_config... /usr/local/pgsql/bin/pg_config
> che=
cking for gcc... gcc
> ...........
> checking how to hardcode l=
ibrary paths into programs... immediate
> checking for library contai=
ning SQLGetPrivateProfileString... no
> *configure:
error: unixODBC library "odbcinst" not found*
> client-66-1xx-1x-x14=
:psqlodbc-08.03.0200 brent1a$

You need unixODBC or iODBC installed. =
unixODBC is used by default,
you can change the expected ODBC manager wi=
th option --with-iodbc.

> ----- Original Message ----
> Fro=
m: Jeremy Faith < jfaith@cemsys.com">jfaith@cemsys.com>
> To: to:pgsql-odbc@postgresql.org" href=3D"mailto:pgsql-odbc@postgresql.org">pgs=
ql-odbc@postgresql.org
> Sent: Monday, September 22, 2008 4:06:28=
AM
> Subject: Re: [ODBC] compiling odbc
>
> Hi,
><=
br>> I think what Tom is saying is to try:-
> PATH=3D$PATH:=
/usr/local/pgsql:/opt/local/bin
>
> Regards,
> Jeremy Fai=
th
>
> Brent Austin wrote:
> > Yes, two PATH items, I =
guess.
> > "export PATH=3D$PATH:/usr/local/pgsql"
> > >>
> takes care of:
> >
> > "checking for pg_config... =
no
> > configure: error: pg_config not found (set PG_CONFIG enviro=
nment
> > variable)"
> >
> > How can I take car=
e of the following as well with out messing up the
> > above?
&=
gt; >
> > "configure: error: unixODBC library "odbcinst" not fo=
und"
> >
> > (I found "odbcinst" is in my /opt/local/bin)=

> >
> > ----- Original Message ----
> > From: T=
om Lane < pgh.pa.us">tgl@sss.pgh.pa.us <mailto: h.pa.us" href=3D"mailto:tgl@sss.pgh.pa.us">tgl@sss.pgh.pa.us>> >> > To: Brent Austin < f=3D"mailto:brent1a@yahoo.com">brent1a@yahoo.com <mailto: =3D"mailto:brent1a@yahoo.com"
href=3D"mailto:brent1a@yahoo.com">brent1a@yahoo.com>>
> &g=
t; Cc: Jeremy Faith < lto:jfaith@cemsys.com">jfaith@cemsys.com <mailto: o:jfaith@cemsys.com" href=3D"mailto:jfaith@cemsys.com">jfaith@cemsys.com >>>;
> mailto:pgsql-odbc@postgresql.org">pgsql-odbc@postgresql.org <mailto:=
ostgresql.org">pgsql-odbc@postgresql.org>
> > Sent: Friday,=
September 19, 2008 3:11:36 PM
> > Subject: Re: [ODBC] compiling o=
dbc
> >
> > Brent Austin < @yahoo.com" href=3D"mailto:brent1a@yahoo.com">brent1a@yahoo.com <mai=
lto: m">brent1a@yahoo.com>
> <mailto: a@yahoo.com"
href=3D"mailto:brent1a@yahoo.com">brent1a@yahoo.com <mailto: lto=3D"mailto:brent1a@yahoo.com" href=3D"mailto:brent1a@yahoo.com">brent1a@=
yahoo.com>>> writes:
> > > How do I tell configure=
that pgsql is in /usr/local/pgsql and ALSO
> > tell it that obcin=
st is in /opt/local/bin ???
> >
> > Two PATH items?
&g=
t; >
> > regards, tom =
lane
> >
>
>
> --
> Sent via pgsql-odbc m=
ailing list ( :pgsql-odbc@postgresql.org">pgsql-odbc@postgresql.org
> <mailt=
o: @postgresql.org">pgsql-odbc@postgresql.org>)
> To make changes=
to your subscription:
> f/pgsql-odbc"
target=3D"_blank">http://www.postgresql.org/mailpref/pgsql-o dbc
>=
;

--
----------------------------------
Zolt=E1n Bösz=
örm=E9nyi
Cybertec Schönig & Schönig GmbH
/www.postgresql.at/" target=3D"_blank">http://www.postgresql.at/
>

dy>
--0-1483291421-1222104529=:58269--

Re: compiling odbc

am 23.09.2008 09:48:11 von Peter Eisentraut

Brent Austin wrote:
> That's the thing, I have unixODBC installed, it is located
> at /opt/local/bin that is why I need help figuring out how to get the
> terminal to recognize where both pg_config AND obdcinst are at during
> the ./configure process.
> PATH=$PATH:/usr/local/pgsql/bin:/opt/local/bin should work but it's
> not recognizing the second part.....the odncinst part.

Try something like

export LDFLAGS=-L/opt/local/lib

--
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

Re: compiling odbc

am 23.09.2008 10:02:13 von Hiroshi Saito

> Brent Austin wrote:
>> That's the thing, I have unixODBC installed, it is located
>> at /opt/local/bin that is why I need help figuring out how to get the
>> terminal to recognize where both pg_config AND obdcinst are at during
>> the ./configure process.
>> PATH=$PATH:/usr/local/pgsql/bin:/opt/local/bin should work but it's
>> not recognizing the second part.....the odncinst part.
>
> Try something like
>
> export LDFLAGS=-L/opt/local/lib

Yeah, or they must be found odbc_config(unixODBC) by configure.

unixODBC is this
hiroshi@developer:~$ which odbc_config
/usr/local/bin/odbc_config
hiroshi@developer:~$ odbc_config --libs
-L/usr/local/lib -lodbc

iODBC is this.
inet% which iodbc-config
/usr/local/bin/iodbc-config
inet% iodbc-config --libs
-L/usr/local/lib -liodbc -liodbcinst

Brent-san, are they found from your path?

Regards,
Hiroshi Saito

--
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc